SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.[DnnProduct_GetContentItemsByVocabularyId] 
	@VocabularyID int
AS
BEGIN
	SELECT c.*
	FROM dbo.DnnProduct_ContentItems As c
		INNER JOIN dbo.DnnProduct_ContentItems_Tags ct ON ct.ContentItemID = c.ContentItemID
		INNER JOIN dbo.DnnProduct_Taxonomy_Terms t ON t.TermID = ct.TermID
	WHERE t.VocabularyID = @VocabularyID
END
GO
